insert overwrite table jms_dim.dim_mysql_lmdm_sys_staff
select
id
,name
,cn_name
,en_name
,code
,country_id
,post_id
,post_name
,post_code
,scope_dispatch
,receiving_range
,contact_number
,township
,network_id
,network_name
,department_id
,department_name
,mobile
,telephone
,id_card
,extension_number
,phone
,is_real_name
,is_enable
,is_delete
,create_by
,update_by
,create_by_name
,update_by_name
,create_time
,update_time
,version
,sort
,sex
,email
,virtual_contracting_area_id
,virtual_contracting_area_code
,virtual_contracting_area_name
,type
,ess_object
,card_type
,incumbency_status
,is_delivery_ground
from jms_ods.yl_cn_mysql_lmdm_sys_staff where dt = '{{ execution_date | cst_ds_nodash }}'
 distribute by 1 ;